{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INPUT","Parameters"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT","index":0,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,9,8,10],[9,9,9,10],[2,9,2,10],[3,9,3,10],[1,8,1,9],[5,9,5,10],[6,9,6,10]]}
[]
[null,null,null,null,null,null,null,null,"Fill In this Section:"]
[null,"Performance Engineering",null,null,null,null,null,null,null,"Number of Devices Sending Flows",null,null,"Features:"]
[null,"GigaFlow Dimensioning Calculator",null,null,null,null,null,null,null,2000]
[null,"Version 18.2.0.0",null,null,null,null,null,null,null,null,null,null,"Archiving","No"]
[null,"Applicable to:",null,null,null,null,null,null,null,"Average Number Of Interfaces"]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,"Date of completion: ","xx / yy / zzzz"]
[null,null,null,null,null,"By: ","A. N. Other",null,null,"Peak Flows/s Required"]
[null,null,null,null,null,null,null,null,null,100000]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Minimum  Servers:",{"$f":"getServerCount(J4,J10,N18)","v":3},null,"Tables Per Day",{"$f":"((1*(J4)*24)/K17)/8","v":2000}]
[null,null,null,null,null,null,null,null,null,"Devices Per Server",{"$f":"J4/K17","v":666.66666666666663},null,"Disk Multiplier",{"$f":"COUNTIF(N4,\"Yes\")+COUNTIF(N5,\"Yes\")+1","v":1}]
[null,null,null,null,null,null,null,null,null,"Flows Per Server",{"$f":"J10/K17","v":33333.333333333336},null,"Disk IO Multiplier",{"$f":"COUNTIF(N7,\"Yes\")+1","v":1}]
[null,null,null,null,null,null,null,null,null,"Max Flows Per Server",{"$f":"N23","v":33372.440005673139},null,"CPU Multiplier",{"$f":"COUNTIF(N4:N6,\"Yes\")+COUNTIF(N8,\"Yes\")+1","v":1}]
[null,null,null,null,null,null,null,null,null,"Storage Per Day Per Server",{"$f":"((K19)*60*60*24*250/1000000000)+(((110*J7*K18)*60*24*6)/1000000000)","v":723.16800000000012},null,"Max Flows/s",{"$f":"100000/N18","v":100000}]
[null,null,null,null,null,null,null,null,null,"Days Of Forensics Available",{"$f":"MIN((N26/K21),40000/N17)","v":20},null,"RAM Multiplier",{"$f":"COUNTIF(N4:N6,\"Yes\")+1","v":1}]
[null,null,null,null,null,null,null,null,null,"Apex/PTC Flows/s",{"$f":"J10*0.3","v":30000},null,"Max Allowed Flows/s",{"$f":"(MIN(100000,20000 + 88016/(1 + ((J4/K17)/297.1046)^2.127587)))/N18","v":33372.440005673139}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Max Devices",{"$f":"1000","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Disk Write Capabilities GB/s",0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capacity GB",50000]
[null,null,null,null,null,null,null,null,null,null,null,null,"IO/Sec",1200]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Devices","Flows/s"]
[null,null,null,null,null,null,null,null,null,null,null,null,1000,{"$f":"(MIN(100000,20000 + 88016/(1 + (M30/297.1046)^2.127587)))/$N$18","v":26186.94660114072}]
[null,null,null,null,null,null,null,null,null,null,null,null,900,27607.210064837072]
[null,null,null,null,null,null,null,null,null,null,null,null,800,29538.860329609539]
[null,null,null,null,null,null,null,null,null,null,null,null,700,32237.246151987987]
[null,null,null,null,null,null,null,null,null,null,null,null,600,36117.303161875207]
[null,null,null,null,null,null,null,null,null,null,null,null,500,41858.31369200856]
[null,null,null,null,null,null,null,null,null,null,null,null,400,50532.576543368945]
[null,null,null,null,null,null,null,null,null,null,null,null,300,63553.990323849823]
[null,null,null,null,null,null,null,null,null,null,null,null,200,81513.70215544432]
[null,null,null,null,null,null,null,null,null,null,null,null,100,100000]

{"sheet":"Parameters","index":1,"n_rows":280,"n_cols":5,"rows_kept":280,"cut":false,"hidden":true,"merged":[]}
[]
["         tabletype        ","   rows   ","  sizebytes  ","  averagebytesperrow   "," tables"]
[" allmaclocations        ",409,114688,280.41075794621003,1]
[" arps                   ",11254,1605632,142.67211658077099,20]
[" cams                   ",4737,573440,121.055520371543,19]
[" customerdevicesettings ",231,40960,177.316017316017,1]
[" deviceinterfaces       ",1062,180224,169.702448210922,2]
[" eventrunners           ",714,401408,562.19607843137203,2]
[" events                 ",41419,35905536,866.88563219778302,59]
[" fwevent                ",1128,73728,65.361702127659498,2]
[" fwextcode              ",1016,73728,72.566929133858196,2]
[" fwextcodestoappids     ",1120,65536,58.514285714285698,2]
[" interfacetypes         ",502,32768,65.274900398406302,2]
[" keys                   ",16931,2334720,137.896166794637,41]
[" keysuser               ",11254,950272,84.438599609027904,20]
[" macaddressvendors      ",71060,4276224,60.177652687869397,2]
[" netflow                ",93237081,22783352832,244.359353463671,196]
[" netflowrt              ",26215449,6079078400,231.88915818302399,241]
[" pg                     ",3169,4448256,1403.6781319028,8]
[" profilingstats         ",729622,43982848,60.281691067429399,6]
[" savedreportdata        ",400,598016,1495.04,1]
[" searchips              ",5792420,359481344,62.0606489170329,14]
[" stresstestresults      ",10334,17981440,1740.0270950261199,1]
[" summarydscp            ",15477432,1449025536,93.621831838770106,24]
[" summaryevents          ",19040,2842624,149.29747899159599,4]
[" summaryfpr             ",289093,27009024,93.426765781253707,24]
[" summarygroup           ",1598563,135028736,84.468823562161703,6]
[" summaryinterfaces      ",7653395,840040448,109.760498184139,24]
[" summarytraffic         ",491645,44457984,90.427003223870798,6]
[" summarytrafficgroups   ",3523929,385097728,109.280785169054,22]
[" systemhealthminute     ",1423892,116334592,81.701836937070993,1]
[" trafficgroups          ",282,221184,784.34042553191398,2]
[" userevents             ",458479,116367360,253.81175582742,1]
[]
[]
[]
["diskspd.exe -c3G -w50 d:\\diskspd\\testfile1.dat"]
[]
[]
["Cache Size","Sent","% Removed"]
[283,2427244,99]
[1,13752,96]
[5,13840,96]
[1,14238,96]
[1,9254,94]
[27,130342,94]
[3,152923,93]
[7,71884,92]
[10,130162,91]
[593,174775,91]
[4,96015,90]
[8,145381,90]
[69,84382,90]
[1266,1592002,87]
[2,23026,87]
[1,657,86]
[591,3054812,85]
[324,31455537,84]
[3257,20970150,81]
[69667,272719753,81]
[471,2669874,80]
[76348,434584090,80]
[10905,146497705,80]
[643,7501762,79]
[1226,21976852,76]
[440,2222536,73]
[8,35396,73]
[252,853427,73]
[13,2109858,72]
[107,629696,71]
[2795,4708549,70]
[177,1037580,70]
[374,13182213,69]
[462,2082081,69]
[5,87059,69]
[6,323258,69]
[7835,111598787,66]
[283,2611320,66]
[761,6381948,66]
[15780,212463057,65]
[539,3314217,65]
[6094,64482779,65]
[815,4593636,65]
[911,5534820,65]
[1,6113,64]
[8686,55717210,64]
[1178,10827648,64]
[857,5539410,63]
[103,2808420,63]
[5,49541,62]
[721,3981714,62]
[2242,43740455,62]
[6500,43794865,62]
[603,2875001,62]
[6269,53807142,61]
[1097,17214264,61]
[763,14212762,61]
[21,119081,61]
[10,70119,60]
[3,69791,60]
[4336,16856444,59]
[2426,22413561,59]
[525,2885437,58]
[207,1386601,57]
[59,731023,56]
[24,289306,56]
[1,30818,56]
[609,20196222,56]
[6696,36061933,56]
[11,2031581,56]
[18341,86946537,53]
[77,615579,53]
[498,4417580,53]
[45,2345131,53]
[243,5575951,52]
[39,3033655,52]
[113,449905,51]
[2617,22056306,51]
[7906,62773731,51]
[815,7366081,50]
[46,447974,50]
[161,4696533,50]
[2668,18626192,49]
[3,551974,48]
[123,1542573,48]
[81,1049493,48]
[571,13808345,47]
[1471,1874530,46]
[488,4052529,46]
[1391,30344907,46]
[1576,8564758,46]
[117,1367125,46]
[255,2789689,46]
[10,70865,45]
[2925,27119725,45]
[479,4652143,45]
[17,397840,44]
[90,1272767,43]
[403,8464174,43]
[23,1504180,42]
[178,2269611,42]
[33,1164820,42]
[151,2843507,42]
[459,4196805,41]
[58,384831,41]
[10,67874,41]
[1951,16378171,41]
[417,8697908,41]
[267,5468118,41]
[6,341163,41]
[413,2508377,40]
[10374,66967305,40]
[194,3363006,40]
[261,2072728,40]
[3,54947,40]
[7,323425,40]
[997,9150374,40]
[488,4612103,40]
[158,3551129,40]
[481,8131221,40]
[8689,67736172,40]
[11,1289808,39]
[6,299461,39]
[10,100909,39]
[25,308584,39]
[1125,9505314,39]
[81,513095,39]
[1010,8349717,39]
[245,2990029,39]
[758,14244248,39]
[15,204220,39]
[6,288156,38]
[1848,11371708,38]
[89,1556312,38]
[12,68423,38]
[1102,8665213,38]
[10,268108,38]
[3,56159,38]
[464,10808912,38]
[2761,19419745,37]
[3,300803,37]
[354,4277778,37]
[570,5901829,37]
[387,3537883,37]
[2,298314,36]
[7,500645,36]
[9,114589,36]
[13,244655,36]
[28,345300,36]
[26,405668,36]
[65,782302,36]
[5,93745,35]
[6,277615,35]
[289,3019881,35]
[19,193019,35]
[4,298673,35]
[169,2958685,35]
[74,1516750,35]
[17,1095746,35]
[38,2462463,35]
[302,2258569,35]
[11,285257,35]
[3,42343,35]
[7,271626,35]
[1,257627,34]
[333,7278505,34]
[9,283669,34]
[27,283496,34]
[492,6248757,34]
[181,3734153,34]
[11,344386,34]
[26,2387748,34]
[217,5428793,34]
[59,951590,34]
[620,5205477,33]
[52,1159215,33]
[3,97338,33]
[27,273203,33]
[803,7686248,33]
[34,308576,33]
[801,5810271,33]
[14,75467,32]
[263,4747632,32]
[18,261428,32]
[44,1086265,32]
[86,1710108,32]
[11,81161,32]
[43,158748,32]
[69,2680371,31]
[436,3964352,31]
[68,2201084,31]
[1,280904,31]
[27,357498,31]
[3,270893,31]
[69,2839444,31]
[21,297097,31]
[73,992124,30]
[12,353840,30]
[228,2132425,30]
[23,358522,30]
[23,138116,30]
[5,295593,30]
[17,284513,30]
[16,264215,30]
[6,825070,30]
[19,771139,29]
[49,602503,29]
[317,2774465,29]
[140,1361912,29]
[1,121399,28]
[17,572168,28]
[138,2237362,28]
[365,1700439,27]
[99,1268824,27]
[22,254075,26]
[25,341037,26]
[10,240606,26]
[150,1725309,25]
[172,4058339,24]
[141,1165326,24]
[54,546159,24]
[108,2291276,24]
[8,954708,23]
[14,737145,23]
[32,514098,23]
[290,2225575,21]
[9,549846,20]
[10,286749,20]
[33,402615,20]
[26,411848,18]
[14,495817,17]
[1008,10475769,16]
[173,1671025,15]
[23,323825,13]
[76,718937,8]
[7,47640,2]
[8,50569,1]
[null,null,{"$f":"AVERAGE(C41:C277)","v":46.189873417721522}]
[null,null,{"$f":"_xlfn.PERCENTILE.INC(C41:C277,0.9)","v":77.200000000000017}]
[null,null,0.25]